package com.trkj.dao.jpa;

import java.math.BigDecimal;
import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojos.Tbscheduling;
public interface IHwcSchedulingDAO extends CrudRepository<Tbscheduling, Long> {
	/**
	 * 根据传入的员工编号查询出该员工的排班信息
	 * @param schedulingStaffNo
	 * @return
	 */
	@Query("select s.schedulingShiftNo from Tbscheduling s where s.schedulingStaffNo = ?1 and rownum <8 order by s.dutyDate desc")
	public List<BigDecimal> queryShiftNo(BigDecimal schedulingStaffNo);
}
